﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DSSalesAgent" targetNamespace="http://tempuri.org/DSSalesAgent.xsd" xmlns:mstns="http://tempuri.org/DSSalesAgent.xsd" xmlns="http://tempuri.org/DSSalesAgent.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Karbel4ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Karbel4ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.TX.Properties.Settings.GlobalReference.Default.Karbel4ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SalesAgentTableAdapter" GeneratorDataComponentClassName="SalesAgentTableAdapter" Name="SalesAgent" UserDataComponentName="SalesAgentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.SalesAgent" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[SalesAgent] WHERE (([SalesAgentId] = @Original_SalesAgentId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SalesAgent] ([ContactId], [Balance], [ModifiedDate], [ModifiedBy]) VALUES (@ContactId, @Balance, @ModifiedDate, @ModifiedBy);
SELECT SalesAgentId, ContactId, Balance, ModifiedDate, ModifiedBy, TS FROM SalesAgent WHERE (SalesAgentId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ContactId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Balance" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Balance" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SalesAgentId, ContactId, Balance, ModifiedDate, ModifiedBy, TS FROM dbo.SalesAgent</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[SalesAgent] SET [ContactId] = @ContactId, [Balance] = @Balance, [ModifiedDate] = @ModifiedDate, [ModifiedBy] = @ModifiedBy WHERE (([SalesAgentId] = @Original_SalesAgentId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)));
SELECT SalesAgentId, ContactId, Balance, ModifiedDate, ModifiedBy, TS FROM SalesAgent WHERE (SalesAgentId = @SalesAgentId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ContactId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Balance" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Balance" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SalesAgentId" ColumnName="SalesAgentId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SalesAgentId" DataSetColumn="SalesAgentId" />
              <Mapping SourceColumn="ContactId" DataSetColumn="ContactId" />
              <Mapping SourceColumn="Balance" DataSetColumn="Balance" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="TS" DataSetColumn="TS" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SalesAgentSalesTableAdapter" GeneratorDataComponentClassName="SalesAgentSalesTableAdapter" Name="SalesAgentSales" UserDataComponentName="SalesAgentSalesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.SalesAgentSales" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[SalesAgentSales] WHERE (([SalesAgentId] = @Original_SalesAgentId) AND ([SalesOrderId] = @Original_SalesOrderId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesOrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesOrderId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SalesAgentSales] ([SalesAgentId], [SalesOrderId], [CommissionPct], [CommissionEarned], [CurrencyRateId], [KapanisTarihi], [ModifiedDate], [ModifiedBy]) VALUES (@SalesAgentId, @SalesOrderId, @CommissionPct, @CommissionEarned, @CurrencyRateId, @KapanisTarihi, @ModifiedDate, @ModifiedBy);
SELECT SalesAgentId, SalesOrderId, CommissionPct, CommissionEarned, CurrencyRateId, KapanisTarihi, ModifiedDate, ModifiedBy, TS FROM SalesAgentSales WHERE (SalesAgentId = @SalesAgentId) AND (SalesOrderId = @SalesOrderId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesOrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesOrderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@CommissionPct" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="CommissionPct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@CommissionEarned" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="CommissionEarned" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CurrencyRateId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrencyRateId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@KapanisTarihi" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="KapanisTarihi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SalesAgentId, SalesOrderId, CommissionPct, CommissionEarned, CurrencyRateId, KapanisTarihi, ModifiedDate, ModifiedBy, TS FROM dbo.SalesAgentSales</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[SalesAgentSales] SET [SalesAgentId] = @SalesAgentId, [SalesOrderId] = @SalesOrderId, [CommissionPct] = @CommissionPct, [CommissionEarned] = @CommissionEarned, [CurrencyRateId] = @CurrencyRateId, [KapanisTarihi] = @KapanisTarihi, [ModifiedDate] = @ModifiedDate, [ModifiedBy] = @ModifiedBy WHERE (([SalesAgentId] = @Original_SalesAgentId) AND ([SalesOrderId] = @Original_SalesOrderId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)));
SELECT SalesAgentId, SalesOrderId, CommissionPct, CommissionEarned, CurrencyRateId, KapanisTarihi, ModifiedDate, ModifiedBy, TS FROM SalesAgentSales WHERE (SalesAgentId = @SalesAgentId) AND (SalesOrderId = @SalesOrderId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesOrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesOrderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@CommissionPct" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="CommissionPct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@CommissionEarned" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="CommissionEarned" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CurrencyRateId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrencyRateId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@KapanisTarihi" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="KapanisTarihi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesOrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesOrderId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SalesAgentId" DataSetColumn="SalesAgentId" />
              <Mapping SourceColumn="SalesOrderId" DataSetColumn="SalesOrderId" />
              <Mapping SourceColumn="CommissionPct" DataSetColumn="CommissionPct" />
              <Mapping SourceColumn="CommissionEarned" DataSetColumn="CommissionEarned" />
              <Mapping SourceColumn="CurrencyRateId" DataSetColumn="CurrencyRateId" />
              <Mapping SourceColumn="KapanisTarihi" DataSetColumn="KapanisTarihi" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="TS" DataSetColumn="TS" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SalesAgentAddressTableAdapter" GeneratorDataComponentClassName="SalesAgentAddressTableAdapter" Name="SalesAgentAddress" UserDataComponentName="SalesAgentAddressTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.SalesAgentAddress" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[SalesAgentAddress] WHERE (([SalesAgentId] = @Original_SalesAgentId) AND ([AddressId] = @Original_AddressId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SalesAgentAddress] ([SalesAgentId], [AddressId], [ModifiedDate], [ModifiedBy]) VALUES (@SalesAgentId, @AddressId, @ModifiedDate, @ModifiedBy);
SELECT SalesAgentId, AddressId, ModifiedDate, ModifiedBy, TS FROM SalesAgentAddress WHERE (AddressId = @AddressId) AND (SalesAgentId = @SalesAgentId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SalesAgentId, AddressId, ModifiedDate, ModifiedBy, TS FROM dbo.SalesAgentAddress</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[SalesAgentAddress] SET [SalesAgentId] = @SalesAgentId, [AddressId] = @AddressId, [ModifiedDate] = @ModifiedDate, [ModifiedBy] = @ModifiedBy WHERE (([SalesAgentId] = @Original_SalesAgentId) AND ([AddressId] = @Original_AddressId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)));
SELECT SalesAgentId, AddressId, ModifiedDate, ModifiedBy, TS FROM SalesAgentAddress WHERE (AddressId = @AddressId) AND (SalesAgentId = @SalesAgentId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SalesAgentId" DataSetColumn="SalesAgentId" />
              <Mapping SourceColumn="AddressId" DataSetColumn="AddressId" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="TS" DataSetColumn="TS" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SalesAgentBankAccountTableAdapter" GeneratorDataComponentClassName="SalesAgentBankAccountTableAdapter" Name="SalesAgentBankAccount" UserDataComponentName="SalesAgentBankAccountTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.SalesAgentBankAccount" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[SalesAgentBankAccount] WHERE (([BankAccountId] = @Original_BankAccountId) AND ([SalesAgentId] = @Original_SalesAgentId) AND ((@IsNull_Preferred = 1 AND [Preferred] IS NULL) OR ([Preferred] = @Original_Preferred)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BankAccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BankAccountId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Preferred" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Preferred" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Preferred" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Preferred" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SalesAgentBankAccount] ([BankAccountId], [SalesAgentId], [Preferred]) VALUES (@BankAccountId, @SalesAgentId, @Preferred);
SELECT BankAccountId, SalesAgentId, Preferred FROM SalesAgentBankAccount WHERE (BankAccountId = @BankAccountId) AND (SalesAgentId = @SalesAgentId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BankAccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BankAccountId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Preferred" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Preferred" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT BankAccountId, SalesAgentId, Preferred FROM dbo.SalesAgentBankAccount</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[SalesAgentBankAccount] SET [BankAccountId] = @BankAccountId, [SalesAgentId] = @SalesAgentId, [Preferred] = @Preferred WHERE (([BankAccountId] = @Original_BankAccountId) AND ([SalesAgentId] = @Original_SalesAgentId) AND ((@IsNull_Preferred = 1 AND [Preferred] IS NULL) OR ([Preferred] = @Original_Preferred)));
SELECT BankAccountId, SalesAgentId, Preferred FROM SalesAgentBankAccount WHERE (BankAccountId = @BankAccountId) AND (SalesAgentId = @SalesAgentId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BankAccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BankAccountId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Preferred" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Preferred" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BankAccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BankAccountId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Preferred" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Preferred" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Preferred" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Preferred" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BankAccountId" DataSetColumn="BankAccountId" />
              <Mapping SourceColumn="SalesAgentId" DataSetColumn="SalesAgentId" />
              <Mapping SourceColumn="Preferred" DataSetColumn="Preferred" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SalesAgentCustomerTableAdapter" GeneratorDataComponentClassName="SalesAgentCustomerTableAdapter" Name="SalesAgentCustomer" UserDataComponentName="SalesAgentCustomerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.SalesAgentCustomer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[SalesAgentCustomer] WHERE (([SalesAgentId] = @Original_SalesAgentId) AND ([CustomerId] = @Original_CustomerId) AND ((@IsNull_CommissionPct = 1 AND [CommissionPct] IS NULL) OR ([CommissionPct] = @Original_CommissionPct)) AND ((@IsNull_PreferredPaymentTerm = 1 AND [PreferredPaymentTerm] IS NULL) OR ([PreferredPaymentTerm] = @Original_PreferredPaymentTerm)) AND ([StartDate] = @Original_StartDate) AND ((@IsNull_EndDate = 1 AND [EndDate] IS NULL) OR ([EndDate] = @Original_EndDate)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CommissionPct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CommissionPct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_CommissionPct" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="CommissionPct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PreferredPaymentTerm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_PreferredPaymentTerm" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SalesAgentCustomer] ([SalesAgentId], [CustomerId], [CommissionPct], [PreferredPaymentTerm], [StartDate], [EndDate]) VALUES (@SalesAgentId, @CustomerId, @CommissionPct, @PreferredPaymentTerm, @StartDate, @EndDate);
SELECT SalesAgentId, CustomerId, CommissionPct, PreferredPaymentTerm, StartDate, EndDate FROM SalesAgentCustomer WHERE (CustomerId = @CustomerId) AND (SalesAgentId = @SalesAgentId) AND (StartDate = @StartDate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@CommissionPct" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="CommissionPct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@PreferredPaymentTerm" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SalesAgentId, CustomerId, CommissionPct, PreferredPaymentTerm, StartDate, EndDate FROM dbo.SalesAgentCustomer</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[SalesAgentCustomer] SET [SalesAgentId] = @SalesAgentId, [CustomerId] = @CustomerId, [CommissionPct] = @CommissionPct, [PreferredPaymentTerm] = @PreferredPaymentTerm, [StartDate] = @StartDate, [EndDate] = @EndDate WHERE (([SalesAgentId] = @Original_SalesAgentId) AND ([CustomerId] = @Original_CustomerId) AND ((@IsNull_CommissionPct = 1 AND [CommissionPct] IS NULL) OR ([CommissionPct] = @Original_CommissionPct)) AND ((@IsNull_PreferredPaymentTerm = 1 AND [PreferredPaymentTerm] IS NULL) OR ([PreferredPaymentTerm] = @Original_PreferredPaymentTerm)) AND ([StartDate] = @Original_StartDate) AND ((@IsNull_EndDate = 1 AND [EndDate] IS NULL) OR ([EndDate] = @Original_EndDate)));
SELECT SalesAgentId, CustomerId, CommissionPct, PreferredPaymentTerm, StartDate, EndDate FROM SalesAgentCustomer WHERE (CustomerId = @CustomerId) AND (SalesAgentId = @SalesAgentId) AND (StartDate = @StartDate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@CommissionPct" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="CommissionPct" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@PreferredPaymentTerm" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CommissionPct" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CommissionPct" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_CommissionPct" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="CommissionPct" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PreferredPaymentTerm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Original_PreferredPaymentTerm" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SalesAgentId" DataSetColumn="SalesAgentId" />
              <Mapping SourceColumn="CustomerId" DataSetColumn="CustomerId" />
              <Mapping SourceColumn="CommissionPct" DataSetColumn="CommissionPct" />
              <Mapping SourceColumn="PreferredPaymentTerm" DataSetColumn="PreferredPaymentTerm" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="EndDate" DataSetColumn="EndDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SalesAgentPaymentTableAdapter" GeneratorDataComponentClassName="SalesAgentPaymentTableAdapter" Name="SalesAgentPayment" UserDataComponentName="SalesAgentPaymentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.SalesAgentPayment" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SalesAgentPayment] ([SalesAgentId], [SalesOrderId], [PlannedPayment], [PlannedDate], [ActualPayment], [ActualDate], [PaymentTermId], [PaidBy], [ModifiedDate], [ModifiedBy]) VALUES (@SalesAgentId, @SalesOrderId, @PlannedPayment, @PlannedDate, @ActualPayment, @ActualDate, @PaymentTermId, @PaidBy, @ModifiedDate, @ModifiedBy)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesOrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesOrderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@PlannedPayment" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="PlannedPayment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PlannedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PlannedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@ActualPayment" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="ActualPayment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ActualDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ActualDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@PaymentTermId" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PaymentTermId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PaidBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PaidBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SalesAgentId, SalesOrderId, PlannedPayment, PlannedDate, ActualPayment, ActualDate, PaymentTermId, PaidBy, ModifiedDate, ModifiedBy, TS FROM dbo.SalesAgentPayment</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SalesAgentId" DataSetColumn="SalesAgentId" />
              <Mapping SourceColumn="SalesOrderId" DataSetColumn="SalesOrderId" />
              <Mapping SourceColumn="PlannedPayment" DataSetColumn="PlannedPayment" />
              <Mapping SourceColumn="PlannedDate" DataSetColumn="PlannedDate" />
              <Mapping SourceColumn="ActualPayment" DataSetColumn="ActualPayment" />
              <Mapping SourceColumn="ActualDate" DataSetColumn="ActualDate" />
              <Mapping SourceColumn="PaymentTermId" DataSetColumn="PaymentTermId" />
              <Mapping SourceColumn="PaidBy" DataSetColumn="PaidBy" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="TS" DataSetColumn="TS" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SalesOrderHeaderTableAdapter" GeneratorDataComponentClassName="SalesOrderHeaderTableAdapter" Name="SalesOrderHeader" UserDataComponentName="SalesOrderHeaderTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.SalesOrderHeader" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[SalesOrderHeader] WHERE (([SalesOrderId] = @Original_SalesOrderId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesOrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesOrderId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SalesOrderHeader] ([RevisionNumber], [OrderDate], [DueDate], [ShipDate], [Status], [SampleFlag], [SalesOrderNumber], [PurchaseOrderNumber], [AccountNumber], [CustomerId], [ContactId], [SalesPersonId], [SalesAgentId], [CountryCode], [BillToAddressId], [ShipToAddressId], [ShipMethodId], [CurrencyRateId], [SubTotal], [TaxAmt], [Freight], [TotalDue], [Comment], [ModifiedDate], [ModifiedBy]) VALUES (@RevisionNumber, @OrderDate, @DueDate, @ShipDate, @Status, @SampleFlag, @SalesOrderNumber, @PurchaseOrderNumber, @AccountNumber, @CustomerId, @ContactId, @SalesPersonId, @SalesAgentId, @CountryCode, @BillToAddressId, @ShipToAddressId, @ShipMethodId, @CurrencyRateId, @SubTotal, @TaxAmt, @Freight, @TotalDue, @Comment, @ModifiedDate, @ModifiedBy);
SELECT SalesOrderId, RevisionNumber, OrderDate, DueDate, ShipDate, Status, SampleFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerId, ContactId, SalesPersonId, SalesAgentId, CountryCode, BillToAddressId, ShipToAddressId, ShipMethodId, CurrencyRateId, SubTotal, TaxAmt, Freight, TotalDue, Comment, ModifiedDate, ModifiedBy, TS FROM SalesOrderHeader WHERE (SalesOrderId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@RevisionNumber" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="RevisionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@OrderDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="OrderDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ShipDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ShipDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SampleFlag" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SampleFlag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SalesOrderNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesOrderNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PurchaseOrderNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PurchaseOrderNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AccountNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AccountNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ContactId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesPersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesPersonId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BillToAddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BillToAddressId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ShipToAddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShipToAddressId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ShipMethodId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShipMethodId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CurrencyRateId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrencyRateId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@SubTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="SubTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@TaxAmt" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TaxAmt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Freight" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Freight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@TotalDue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TotalDue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SalesOrderId, RevisionNumber, OrderDate, DueDate, ShipDate, Status, SampleFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerId, ContactId, SalesPersonId, SalesAgentId, CountryCode, BillToAddressId, ShipToAddressId, ShipMethodId, CurrencyRateId, SubTotal, TaxAmt, Freight, TotalDue, Comment, ModifiedDate, ModifiedBy, TS FROM dbo.SalesOrderHeader</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[SalesOrderHeader] SET [RevisionNumber] = @RevisionNumber, [OrderDate] = @OrderDate, [DueDate] = @DueDate, [ShipDate] = @ShipDate, [Status] = @Status, [SampleFlag] = @SampleFlag, [SalesOrderNumber] = @SalesOrderNumber, [PurchaseOrderNumber] = @PurchaseOrderNumber, [AccountNumber] = @AccountNumber, [CustomerId] = @CustomerId, [ContactId] = @ContactId, [SalesPersonId] = @SalesPersonId, [SalesAgentId] = @SalesAgentId, [CountryCode] = @CountryCode, [BillToAddressId] = @BillToAddressId, [ShipToAddressId] = @ShipToAddressId, [ShipMethodId] = @ShipMethodId, [CurrencyRateId] = @CurrencyRateId, [SubTotal] = @SubTotal, [TaxAmt] = @TaxAmt, [Freight] = @Freight, [TotalDue] = @TotalDue, [Comment] = @Comment, [ModifiedDate] = @ModifiedDate, [ModifiedBy] = @ModifiedBy WHERE (([SalesOrderId] = @Original_SalesOrderId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)));
SELECT SalesOrderId, RevisionNumber, OrderDate, DueDate, ShipDate, Status, SampleFlag, SalesOrderNumber, PurchaseOrderNumber, AccountNumber, CustomerId, ContactId, SalesPersonId, SalesAgentId, CountryCode, BillToAddressId, ShipToAddressId, ShipMethodId, CurrencyRateId, SubTotal, TaxAmt, Freight, TotalDue, Comment, ModifiedDate, ModifiedBy, TS FROM SalesOrderHeader WHERE (SalesOrderId = @SalesOrderId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@RevisionNumber" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="RevisionNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@OrderDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="OrderDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ShipDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ShipDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="Status" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@SampleFlag" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="SampleFlag" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SalesOrderNumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SalesOrderNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PurchaseOrderNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PurchaseOrderNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AccountNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AccountNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ContactId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ContactId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesPersonId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesPersonId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SalesAgentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesAgentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BillToAddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BillToAddressId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ShipToAddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShipToAddressId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ShipMethodId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ShipMethodId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CurrencyRateId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CurrencyRateId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@SubTotal" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="SubTotal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@TaxAmt" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TaxAmt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Freight" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Freight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@TotalDue" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="TotalDue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SalesOrderId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SalesOrderId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SalesOrderId" ColumnName="SalesOrderId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@SalesOrderId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="SalesOrderId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SalesOrderId" DataSetColumn="SalesOrderId" />
              <Mapping SourceColumn="RevisionNumber" DataSetColumn="RevisionNumber" />
              <Mapping SourceColumn="OrderDate" DataSetColumn="OrderDate" />
              <Mapping SourceColumn="DueDate" DataSetColumn="DueDate" />
              <Mapping SourceColumn="ShipDate" DataSetColumn="ShipDate" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="SampleFlag" DataSetColumn="SampleFlag" />
              <Mapping SourceColumn="SalesOrderNumber" DataSetColumn="SalesOrderNumber" />
              <Mapping SourceColumn="PurchaseOrderNumber" DataSetColumn="PurchaseOrderNumber" />
              <Mapping SourceColumn="AccountNumber" DataSetColumn="AccountNumber" />
              <Mapping SourceColumn="CustomerId" DataSetColumn="CustomerId" />
              <Mapping SourceColumn="ContactId" DataSetColumn="ContactId" />
              <Mapping SourceColumn="SalesPersonId" DataSetColumn="SalesPersonId" />
              <Mapping SourceColumn="SalesAgentId" DataSetColumn="SalesAgentId" />
              <Mapping SourceColumn="CountryCode" DataSetColumn="CountryCode" />
              <Mapping SourceColumn="BillToAddressId" DataSetColumn="BillToAddressId" />
              <Mapping SourceColumn="ShipToAddressId" DataSetColumn="ShipToAddressId" />
              <Mapping SourceColumn="ShipMethodId" DataSetColumn="ShipMethodId" />
              <Mapping SourceColumn="CurrencyRateId" DataSetColumn="CurrencyRateId" />
              <Mapping SourceColumn="SubTotal" DataSetColumn="SubTotal" />
              <Mapping SourceColumn="TaxAmt" DataSetColumn="TaxAmt" />
              <Mapping SourceColumn="Freight" DataSetColumn="Freight" />
              <Mapping SourceColumn="TotalDue" DataSetColumn="TotalDue" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="TS" DataSetColumn="TS" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomerTableAdapter" GeneratorDataComponentClassName="CustomerTableAdapter" Name="Customer" UserDataComponentName="CustomerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.Customer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Customer] WHERE (([CustomerId] = @Original_CustomerId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Customer] ([AccountNumber], [Name], [Demographics], [CountryCode], [PreferredShipMethod], [PreferredPaymentTerm], [VergiDairesi], [VergiNo], [ModifiedDate], [ModifiedBy]) VALUES (@AccountNumber, @Name, @Demographics, @CountryCode, @PreferredShipMethod, @PreferredPaymentTerm, @VergiDairesi, @VergiNo, @ModifiedDate, @ModifiedBy);
SELECT CustomerId, AccountNumber, Name, Demographics, CountryCode, PreferredShipMethod, PreferredPaymentTerm, VergiDairesi, VergiNo, ModifiedDate, ModifiedBy, TS FROM Customer WHERE (CustomerId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AccountNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AccountNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Xml" Direction="Input" ParameterName="@Demographics" Precision="0" ProviderType="Xml" Scale="0" Size="0" SourceColumn="Demographics" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PreferredShipMethod" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PreferredShipMethod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@PreferredPaymentTerm" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VergiDairesi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VergiDairesi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VergiNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VergiNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CustomerId, AccountNumber, Name, Demographics, CountryCode, PreferredShipMethod, PreferredPaymentTerm, VergiDairesi, VergiNo, ModifiedDate, ModifiedBy, TS FROM dbo.Customer</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Customer] SET [AccountNumber] = @AccountNumber, [Name] = @Name, [Demographics] = @Demographics, [CountryCode] = @CountryCode, [PreferredShipMethod] = @PreferredShipMethod, [PreferredPaymentTerm] = @PreferredPaymentTerm, [VergiDairesi] = @VergiDairesi, [VergiNo] = @VergiNo, [ModifiedDate] = @ModifiedDate, [ModifiedBy] = @ModifiedBy WHERE (([CustomerId] = @Original_CustomerId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)));
SELECT CustomerId, AccountNumber, Name, Demographics, CountryCode, PreferredShipMethod, PreferredPaymentTerm, VergiDairesi, VergiNo, ModifiedDate, ModifiedBy, TS FROM Customer WHERE (CustomerId = @CustomerId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AccountNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AccountNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Xml" Direction="Input" ParameterName="@Demographics" Precision="0" ProviderType="Xml" Scale="0" Size="0" SourceColumn="Demographics" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PreferredShipMethod" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PreferredShipMethod" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@PreferredPaymentTerm" Precision="0" ProviderType="TinyInt" Scale="0" Size="0" SourceColumn="PreferredPaymentTerm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VergiDairesi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VergiDairesi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VergiNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VergiNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CustomerId" ColumnName="CustomerId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CustomerId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CustomerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CustomerId" DataSetColumn="CustomerId" />
              <Mapping SourceColumn="AccountNumber" DataSetColumn="AccountNumber" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Demographics" DataSetColumn="Demographics" />
              <Mapping SourceColumn="CountryCode" DataSetColumn="CountryCode" />
              <Mapping SourceColumn="PreferredShipMethod" DataSetColumn="PreferredShipMethod" />
              <Mapping SourceColumn="PreferredPaymentTerm" DataSetColumn="PreferredPaymentTerm" />
              <Mapping SourceColumn="VergiDairesi" DataSetColumn="VergiDairesi" />
              <Mapping SourceColumn="VergiNo" DataSetColumn="VergiNo" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="TS" DataSetColumn="TS" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AddressTableAdapter" GeneratorDataComponentClassName="AddressTableAdapter" Name="Address" UserDataComponentName="AddressTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.Address" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Address] WHERE (([AddressId] = @Original_AddressId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Address] ([AddressLine1], [AddressLine2], [City], [State], [CountryCode], [PostalCode], [UseCount], [ModifiedDate], [ModifiedBy]) VALUES (@AddressLine1, @AddressLine2, @City, @State, @CountryCode, @PostalCode, @UseCount, @ModifiedDate, @ModifiedBy);
SELECT AddressId, AddressLine1, AddressLine2, City, State, CountryCode, PostalCode, UseCount, ModifiedDate, ModifiedBy, TS FROM Address WHERE (AddressId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AddressLine1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AddressLine1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AddressLine2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AddressLine2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PostalCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UseCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UseCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT AddressId, AddressLine1, AddressLine2, City, State, CountryCode, PostalCode, UseCount, ModifiedDate, ModifiedBy, TS FROM dbo.Address</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Address] SET [AddressLine1] = @AddressLine1, [AddressLine2] = @AddressLine2, [City] = @City, [State] = @State, [CountryCode] = @CountryCode, [PostalCode] = @PostalCode, [UseCount] = @UseCount, [ModifiedDate] = @ModifiedDate, [ModifiedBy] = @ModifiedBy WHERE (([AddressId] = @Original_AddressId) AND ((@IsNull_TS = 1 AND [TS] IS NULL) OR ([TS] = @Original_TS)));
SELECT AddressId, AddressLine1, AddressLine2, City, State, CountryCode, PostalCode, UseCount, ModifiedDate, ModifiedBy, TS FROM Address WHERE (AddressId = @AddressId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AddressLine1" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AddressLine1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AddressLine2" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AddressLine2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@City" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@State" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PostalCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PostalCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UseCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UseCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AddressId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_TS" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="TS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="AddressId" ColumnName="AddressId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AddressId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AddressId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AddressId" DataSetColumn="AddressId" />
              <Mapping SourceColumn="AddressLine1" DataSetColumn="AddressLine1" />
              <Mapping SourceColumn="AddressLine2" DataSetColumn="AddressLine2" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="State" DataSetColumn="State" />
              <Mapping SourceColumn="CountryCode" DataSetColumn="CountryCode" />
              <Mapping SourceColumn="PostalCode" DataSetColumn="PostalCode" />
              <Mapping SourceColumn="UseCount" DataSetColumn="UseCount" />
              <Mapping SourceColumn="ModifiedDate" DataSetColumn="ModifiedDate" />
              <Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
              <Mapping SourceColumn="TS" DataSetColumn="TS" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BankAccountTableAdapter" GeneratorDataComponentClassName="BankAccountTableAdapter" Name="BankAccount" UserDataComponentName="BankAccountTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Karbel4ConnectionString (Settings)" DbObjectName="Karbel4.dbo.BankAccount" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[BankAccount] WHERE (([BankAccountId] = @Original_BankAccountId) AND ([BankName] = @Original_BankName) AND ([BranchName] = @Original_BranchName) AND ([BranchCode] = @Original_BranchCode) AND ([CountryCode] = @Original_CountryCode) AND ((@IsNull_AccountNumber = 1 AND [AccountNumber] IS NULL) OR ([AccountNumber] = @Original_AccountNumber)) AND ((@IsNull_IBANCode = 1 AND [IBANCode] IS NULL) OR ([IBANCode] = @Original_IBANCode)) AND ((@IsNull_UseCount = 1 AND [UseCount] IS NULL) OR ([UseCount] = @Original_UseCount)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BankAccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BankAccountId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BankName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BranchName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BranchName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BranchCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BranchCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CountryCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccountNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AccountNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AccountNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IBANCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IBANCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IBANCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IBANCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UseCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UseCount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UseCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UseCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[BankAccount] ([BankName], [BranchName], [BranchCode], [CountryCode], [AccountNumber], [IBANCode], [UseCount]) VALUES (@BankName, @BranchName, @BranchCode, @CountryCode, @AccountNumber, @IBANCode, @UseCount);
SELECT BankAccountId, BankName, BranchName, BranchCode, CountryCode, AccountNumber, IBANCode, UseCount FROM BankAccount WHERE (BankAccountId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BankName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BranchName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BranchName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BranchCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BranchCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AccountNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AccountNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IBANCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IBANCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UseCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UseCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT BankAccountId, BankName, BranchName, BranchCode, CountryCode, AccountNumber, IBANCode, UseCount FROM dbo.BankAccount</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[BankAccount] SET [BankName] = @BankName, [BranchName] = @BranchName, [BranchCode] = @BranchCode, [CountryCode] = @CountryCode, [AccountNumber] = @AccountNumber, [IBANCode] = @IBANCode, [UseCount] = @UseCount WHERE (([BankAccountId] = @Original_BankAccountId) AND ([BankName] = @Original_BankName) AND ([BranchName] = @Original_BranchName) AND ([BranchCode] = @Original_BranchCode) AND ([CountryCode] = @Original_CountryCode) AND ((@IsNull_AccountNumber = 1 AND [AccountNumber] IS NULL) OR ([AccountNumber] = @Original_AccountNumber)) AND ((@IsNull_IBANCode = 1 AND [IBANCode] IS NULL) OR ([IBANCode] = @Original_IBANCode)) AND ((@IsNull_UseCount = 1 AND [UseCount] IS NULL) OR ([UseCount] = @Original_UseCount)));
SELECT BankAccountId, BankName, BranchName, BranchCode, CountryCode, AccountNumber, IBANCode, UseCount FROM BankAccount WHERE (BankAccountId = @BankAccountId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BankName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BranchName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BranchName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BranchCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BranchCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CountryCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AccountNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AccountNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IBANCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IBANCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UseCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UseCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BankAccountId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BankAccountId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BankName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BankName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BranchName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BranchName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BranchCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BranchCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CountryCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CountryCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccountNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccountNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AccountNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AccountNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IBANCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IBANCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IBANCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IBANCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UseCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UseCount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UseCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UseCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="BankAccountId" ColumnName="BankAccountId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@BankAccountId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="BankAccountId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="BankAccountId" DataSetColumn="BankAccountId" />
              <Mapping SourceColumn="BankName" DataSetColumn="BankName" />
              <Mapping SourceColumn="BranchName" DataSetColumn="BranchName" />
              <Mapping SourceColumn="BranchCode" DataSetColumn="BranchCode" />
              <Mapping SourceColumn="CountryCode" DataSetColumn="CountryCode" />
              <Mapping SourceColumn="AccountNumber" DataSetColumn="AccountNumber" />
              <Mapping SourceColumn="IBANCode" DataSetColumn="IBANCode" />
              <Mapping SourceColumn="UseCount" DataSetColumn="UseCount" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DSSalesAgent" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="DSSalesAgent" msprop:Generator_UserDSName="DSSalesAgent" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="SalesAgent" msprop:Generator_UserTableName="SalesAgent" msprop:Generator_RowDeletedName="SalesAgentRowDeleted" msprop:Generator_TableClassName="SalesAgentDataTable" msprop:Generator_RowChangedName="SalesAgentRowChanged" msprop:Generator_RowClassName="SalesAgentRow" msprop:Generator_RowChangingName="SalesAgentRowChanging" msprop:Generator_RowEvArgName="SalesAgentRowChangeEvent" msprop:Generator_RowEvHandlerName="SalesAgentRowChangeEventHandler" msprop:Generator_TablePropName="SalesAgent" msprop:Generator_TableVarName="tableSalesAgent" msprop:Generator_RowDeletingName="SalesAgentRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SalesAgentId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="SalesAgentId" msprop:Generator_ColumnPropNameInRow="SalesAgentId" msprop:Generator_ColumnVarNameInTable="columnSalesAgentId" msprop:Generator_ColumnPropNameInTable="SalesAgentIdColumn" type="xs:int" />
              <xs:element name="ContactId" msprop:Generator_UserColumnName="ContactId" msprop:Generator_ColumnPropNameInRow="ContactId" msprop:Generator_ColumnVarNameInTable="columnContactId" msprop:Generator_ColumnPropNameInTable="ContactIdColumn" type="xs:int" />
              <xs:element name="Balance" msprop:Generator_UserColumnName="Balance" msprop:Generator_ColumnPropNameInRow="Balance" msprop:Generator_ColumnVarNameInTable="columnBalance" msprop:Generator_ColumnPropNameInTable="BalanceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TS" msprop:Generator_ColumnPropNameInRow="TS" msprop:Generator_ColumnVarNameInTable="columnTS" msprop:Generator_ColumnPropNameInTable="TSColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SalesAgentSales" msprop:Generator_UserTableName="SalesAgentSales" msprop:Generator_RowDeletedName="SalesAgentSalesRowDeleted" msprop:Generator_TableClassName="SalesAgentSalesDataTable" msprop:Generator_RowChangedName="SalesAgentSalesRowChanged" msprop:Generator_RowClassName="SalesAgentSalesRow" msprop:Generator_RowChangingName="SalesAgentSalesRowChanging" msprop:Generator_RowEvArgName="SalesAgentSalesRowChangeEvent" msprop:Generator_RowEvHandlerName="SalesAgentSalesRowChangeEventHandler" msprop:Generator_TablePropName="SalesAgentSales" msprop:Generator_TableVarName="tableSalesAgentSales" msprop:Generator_RowDeletingName="SalesAgentSalesRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SalesAgentId" msprop:Generator_UserColumnName="SalesAgentId" msprop:Generator_ColumnPropNameInRow="SalesAgentId" msprop:Generator_ColumnVarNameInTable="columnSalesAgentId" msprop:Generator_ColumnPropNameInTable="SalesAgentIdColumn" type="xs:int" />
              <xs:element name="SalesOrderId" msprop:Generator_UserColumnName="SalesOrderId" msprop:Generator_ColumnPropNameInRow="SalesOrderId" msprop:Generator_ColumnVarNameInTable="columnSalesOrderId" msprop:Generator_ColumnPropNameInTable="SalesOrderIdColumn" type="xs:int" />
              <xs:element name="CommissionPct" msprop:Generator_UserColumnName="CommissionPct" msprop:Generator_ColumnPropNameInRow="CommissionPct" msprop:Generator_ColumnVarNameInTable="columnCommissionPct" msprop:Generator_ColumnPropNameInTable="CommissionPctColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="CommissionEarned" msprop:Generator_UserColumnName="CommissionEarned" msprop:Generator_ColumnPropNameInRow="CommissionEarned" msprop:Generator_ColumnVarNameInTable="columnCommissionEarned" msprop:Generator_ColumnPropNameInTable="CommissionEarnedColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="CurrencyRateId" msprop:Generator_UserColumnName="CurrencyRateId" msprop:Generator_ColumnPropNameInRow="CurrencyRateId" msprop:Generator_ColumnVarNameInTable="columnCurrencyRateId" msprop:Generator_ColumnPropNameInTable="CurrencyRateIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="KapanisTarihi" msprop:Generator_UserColumnName="KapanisTarihi" msprop:Generator_ColumnPropNameInRow="KapanisTarihi" msprop:Generator_ColumnVarNameInTable="columnKapanisTarihi" msprop:Generator_ColumnPropNameInTable="KapanisTarihiColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TS" msprop:Generator_ColumnPropNameInRow="TS" msprop:Generator_ColumnVarNameInTable="columnTS" msprop:Generator_ColumnPropNameInTable="TSColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SalesAgentAddress" msprop:Generator_UserTableName="SalesAgentAddress" msprop:Generator_RowDeletedName="SalesAgentAddressRowDeleted" msprop:Generator_TableClassName="SalesAgentAddressDataTable" msprop:Generator_RowChangedName="SalesAgentAddressRowChanged" msprop:Generator_RowClassName="SalesAgentAddressRow" msprop:Generator_RowChangingName="SalesAgentAddressRowChanging" msprop:Generator_RowEvArgName="SalesAgentAddressRowChangeEvent" msprop:Generator_RowEvHandlerName="SalesAgentAddressRowChangeEventHandler" msprop:Generator_TablePropName="SalesAgentAddress" msprop:Generator_TableVarName="tableSalesAgentAddress" msprop:Generator_RowDeletingName="SalesAgentAddressRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SalesAgentId" msprop:Generator_UserColumnName="SalesAgentId" msprop:Generator_ColumnPropNameInRow="SalesAgentId" msprop:Generator_ColumnVarNameInTable="columnSalesAgentId" msprop:Generator_ColumnPropNameInTable="SalesAgentIdColumn" type="xs:int" />
              <xs:element name="AddressId" msprop:Generator_UserColumnName="AddressId" msprop:Generator_ColumnPropNameInRow="AddressId" msprop:Generator_ColumnVarNameInTable="columnAddressId" msprop:Generator_ColumnPropNameInTable="AddressIdColumn" type="xs:int" />
              <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" />
              <xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TS" msprop:Generator_ColumnPropNameInRow="TS" msprop:Generator_ColumnVarNameInTable="columnTS" msprop:Generator_ColumnPropNameInTable="TSColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SalesAgentBankAccount" msprop:Generator_UserTableName="SalesAgentBankAccount" msprop:Generator_RowDeletedName="SalesAgentBankAccountRowDeleted" msprop:Generator_TableClassName="SalesAgentBankAccountDataTable" msprop:Generator_RowChangedName="SalesAgentBankAccountRowChanged" msprop:Generator_RowClassName="SalesAgentBankAccountRow" msprop:Generator_RowChangingName="SalesAgentBankAccountRowChanging" msprop:Generator_RowEvArgName="SalesAgentBankAccountRowChangeEvent" msprop:Generator_RowEvHandlerName="SalesAgentBankAccountRowChangeEventHandler" msprop:Generator_TablePropName="SalesAgentBankAccount" msprop:Generator_TableVarName="tableSalesAgentBankAccount" msprop:Generator_RowDeletingName="SalesAgentBankAccountRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BankAccountId" msprop:Generator_UserColumnName="BankAccountId" msprop:Generator_ColumnPropNameInRow="BankAccountId" msprop:Generator_ColumnVarNameInTable="columnBankAccountId" msprop:Generator_ColumnPropNameInTable="BankAccountIdColumn" type="xs:int" />
              <xs:element name="SalesAgentId" msprop:Generator_UserColumnName="SalesAgentId" msprop:Generator_ColumnPropNameInRow="SalesAgentId" msprop:Generator_ColumnVarNameInTable="columnSalesAgentId" msprop:Generator_ColumnPropNameInTable="SalesAgentIdColumn" type="xs:int" />
              <xs:element name="Preferred" msprop:Generator_UserColumnName="Preferred" msprop:Generator_ColumnPropNameInRow="Preferred" msprop:Generator_ColumnVarNameInTable="columnPreferred" msprop:Generator_ColumnPropNameInTable="PreferredColumn" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SalesAgentCustomer" msprop:Generator_UserTableName="SalesAgentCustomer" msprop:Generator_RowDeletedName="SalesAgentCustomerRowDeleted" msprop:Generator_TableClassName="SalesAgentCustomerDataTable" msprop:Generator_RowChangedName="SalesAgentCustomerRowChanged" msprop:Generator_RowClassName="SalesAgentCustomerRow" msprop:Generator_RowChangingName="SalesAgentCustomerRowChanging" msprop:Generator_RowEvArgName="SalesAgentCustomerRowChangeEvent" msprop:Generator_RowEvHandlerName="SalesAgentCustomerRowChangeEventHandler" msprop:Generator_TablePropName="SalesAgentCustomer" msprop:Generator_TableVarName="tableSalesAgentCustomer" msprop:Generator_RowDeletingName="SalesAgentCustomerRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SalesAgentId" msprop:Generator_UserColumnName="SalesAgentId" msprop:Generator_ColumnPropNameInRow="SalesAgentId" msprop:Generator_ColumnVarNameInTable="columnSalesAgentId" msprop:Generator_ColumnPropNameInTable="SalesAgentIdColumn" type="xs:int" />
              <xs:element name="CustomerId" msprop:Generator_UserColumnName="CustomerId" msprop:Generator_ColumnPropNameInRow="CustomerId" msprop:Generator_ColumnVarNameInTable="columnCustomerId" msprop:Generator_ColumnPropNameInTable="CustomerIdColumn" type="xs:int" />
              <xs:element name="CommissionPct" msprop:Generator_UserColumnName="CommissionPct" msprop:Generator_ColumnPropNameInRow="CommissionPct" msprop:Generator_ColumnVarNameInTable="columnCommissionPct" msprop:Generator_ColumnPropNameInTable="CommissionPctColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="PreferredPaymentTerm" msprop:Generator_UserColumnName="PreferredPaymentTerm" msprop:Generator_ColumnPropNameInRow="PreferredPaymentTerm" msprop:Generator_ColumnVarNameInTable="columnPreferredPaymentTerm" msprop:Generator_ColumnPropNameInTable="PreferredPaymentTermColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="StartDate" msprop:Generator_UserColumnName="StartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" type="xs:dateTime" />
              <xs:element name="EndDate" msprop:Generator_UserColumnName="EndDate" msprop:Generator_ColumnPropNameInRow="EndDate" msprop:Generator_ColumnVarNameInTable="columnEndDate" msprop:Generator_ColumnPropNameInTable="EndDateColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SalesAgentPayment" msprop:Generator_UserTableName="SalesAgentPayment" msprop:Generator_RowDeletedName="SalesAgentPaymentRowDeleted" msprop:Generator_TableClassName="SalesAgentPaymentDataTable" msprop:Generator_RowChangedName="SalesAgentPaymentRowChanged" msprop:Generator_RowClassName="SalesAgentPaymentRow" msprop:Generator_RowChangingName="SalesAgentPaymentRowChanging" msprop:Generator_RowEvArgName="SalesAgentPaymentRowChangeEvent" msprop:Generator_RowEvHandlerName="SalesAgentPaymentRowChangeEventHandler" msprop:Generator_TablePropName="SalesAgentPayment" msprop:Generator_TableVarName="tableSalesAgentPayment" msprop:Generator_RowDeletingName="SalesAgentPaymentRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SalesAgentId" msprop:Generator_UserColumnName="SalesAgentId" msprop:Generator_ColumnPropNameInRow="SalesAgentId" msprop:Generator_ColumnVarNameInTable="columnSalesAgentId" msprop:Generator_ColumnPropNameInTable="SalesAgentIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SalesOrderId" msprop:Generator_UserColumnName="SalesOrderId" msprop:Generator_ColumnPropNameInRow="SalesOrderId" msprop:Generator_ColumnVarNameInTable="columnSalesOrderId" msprop:Generator_ColumnPropNameInTable="SalesOrderIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="PlannedPayment" msprop:Generator_UserColumnName="PlannedPayment" msprop:Generator_ColumnPropNameInRow="PlannedPayment" msprop:Generator_ColumnVarNameInTable="columnPlannedPayment" msprop:Generator_ColumnPropNameInTable="PlannedPaymentColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="PlannedDate" msprop:Generator_UserColumnName="PlannedDate" msprop:Generator_ColumnPropNameInRow="PlannedDate" msprop:Generator_ColumnVarNameInTable="columnPlannedDate" msprop:Generator_ColumnPropNameInTable="PlannedDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ActualPayment" msprop:Generator_UserColumnName="ActualPayment" msprop:Generator_ColumnPropNameInRow="ActualPayment" msprop:Generator_ColumnVarNameInTable="columnActualPayment" msprop:Generator_ColumnPropNameInTable="ActualPaymentColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ActualDate" msprop:Generator_UserColumnName="ActualDate" msprop:Generator_ColumnPropNameInRow="ActualDate" msprop:Generator_ColumnVarNameInTable="columnActualDate" msprop:Generator_ColumnPropNameInTable="ActualDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PaymentTermId" msprop:Generator_UserColumnName="PaymentTermId" msprop:Generator_ColumnPropNameInRow="PaymentTermId" msprop:Generator_ColumnVarNameInTable="columnPaymentTermId" msprop:Generator_ColumnPropNameInTable="PaymentTermIdColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="PaidBy" msprop:Generator_UserColumnName="PaidBy" msprop:Generator_ColumnPropNameInRow="PaidBy" msprop:Generator_ColumnVarNameInTable="columnPaidBy" msprop:Generator_ColumnPropNameInTable="PaidByColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TS" msprop:Generator_ColumnPropNameInRow="TS" msprop:Generator_ColumnVarNameInTable="columnTS" msprop:Generator_ColumnPropNameInTable="TSColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SalesOrderHeader" msprop:Generator_UserTableName="SalesOrderHeader" msprop:Generator_RowDeletedName="SalesOrderHeaderRowDeleted" msprop:Generator_TableClassName="SalesOrderHeaderDataTable" msprop:Generator_RowChangedName="SalesOrderHeaderRowChanged" msprop:Generator_RowClassName="SalesOrderHeaderRow" msprop:Generator_RowChangingName="SalesOrderHeaderRowChanging" msprop:Generator_RowEvArgName="SalesOrderHeaderRowChangeEvent" msprop:Generator_RowEvHandlerName="SalesOrderHeaderRowChangeEventHandler" msprop:Generator_TablePropName="SalesOrderHeader" msprop:Generator_TableVarName="tableSalesOrderHeader" msprop:Generator_RowDeletingName="SalesOrderHeaderRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SalesOrderId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="SalesOrderId" msprop:Generator_ColumnPropNameInRow="SalesOrderId" msprop:Generator_ColumnVarNameInTable="columnSalesOrderId" msprop:Generator_ColumnPropNameInTable="SalesOrderIdColumn" type="xs:int" />
              <xs:element name="RevisionNumber" msprop:Generator_UserColumnName="RevisionNumber" msprop:Generator_ColumnPropNameInRow="RevisionNumber" msprop:Generator_ColumnVarNameInTable="columnRevisionNumber" msprop:Generator_ColumnPropNameInTable="RevisionNumberColumn" type="xs:unsignedByte" />
              <xs:element name="OrderDate" msprop:Generator_UserColumnName="OrderDate" msprop:Generator_ColumnPropNameInRow="OrderDate" msprop:Generator_ColumnVarNameInTable="columnOrderDate" msprop:Generator_ColumnPropNameInTable="OrderDateColumn" type="xs:dateTime" />
              <xs:element name="DueDate" msprop:Generator_UserColumnName="DueDate" msprop:Generator_ColumnPropNameInRow="DueDate" msprop:Generator_ColumnVarNameInTable="columnDueDate" msprop:Generator_ColumnPropNameInTable="DueDateColumn" type="xs:dateTime" />
              <xs:element name="ShipDate" msprop:Generator_UserColumnName="ShipDate" msprop:Generator_ColumnPropNameInRow="ShipDate" msprop:Generator_ColumnVarNameInTable="columnShipDate" msprop:Generator_ColumnPropNameInTable="ShipDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" type="xs:unsignedByte" />
              <xs:element name="SampleFlag" msprop:Generator_UserColumnName="SampleFlag" msprop:Generator_ColumnPropNameInRow="SampleFlag" msprop:Generator_ColumnVarNameInTable="columnSampleFlag" msprop:Generator_ColumnPropNameInTable="SampleFlagColumn" type="xs:boolean" />
              <xs:element name="SalesOrderNumber" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SalesOrderNumber" msprop:Generator_ColumnPropNameInRow="SalesOrderNumber" msprop:Generator_ColumnVarNameInTable="columnSalesOrderNumber" msprop:Generator_ColumnPropNameInTable="SalesOrderNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PurchaseOrderNumber" msprop:Generator_UserColumnName="PurchaseOrderNumber" msprop:Generator_ColumnPropNameInRow="PurchaseOrderNumber" msprop:Generator_ColumnVarNameInTable="columnPurchaseOrderNumber" msprop:Generator_ColumnPropNameInTable="PurchaseOrderNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccountNumber" msprop:Generator_UserColumnName="AccountNumber" msprop:Generator_ColumnPropNameInRow="AccountNumber" msprop:Generator_ColumnVarNameInTable="columnAccountNumber" msprop:Generator_ColumnPropNameInTable="AccountNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CustomerId" msprop:Generator_UserColumnName="CustomerId" msprop:Generator_ColumnPropNameInRow="CustomerId" msprop:Generator_ColumnVarNameInTable="columnCustomerId" msprop:Generator_ColumnPropNameInTable="CustomerIdColumn" type="xs:int" />
              <xs:element name="ContactId" msprop:Generator_UserColumnName="ContactId" msprop:Generator_ColumnPropNameInRow="ContactId" msprop:Generator_ColumnVarNameInTable="columnContactId" msprop:Generator_ColumnPropNameInTable="ContactIdColumn" type="xs:int" />
              <xs:element name="SalesPersonId" msprop:Generator_UserColumnName="SalesPersonId" msprop:Generator_ColumnPropNameInRow="SalesPersonId" msprop:Generator_ColumnVarNameInTable="columnSalesPersonId" msprop:Generator_ColumnPropNameInTable="SalesPersonIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SalesAgentId" msprop:Generator_UserColumnName="SalesAgentId" msprop:Generator_ColumnPropNameInRow="SalesAgentId" msprop:Generator_ColumnVarNameInTable="columnSalesAgentId" msprop:Generator_ColumnPropNameInTable="SalesAgentIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CountryCode" msprop:Generator_UserColumnName="CountryCode" msprop:Generator_ColumnPropNameInRow="CountryCode" msprop:Generator_ColumnVarNameInTable="columnCountryCode" msprop:Generator_ColumnPropNameInTable="CountryCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillToAddressId" msprop:Generator_UserColumnName="BillToAddressId" msprop:Generator_ColumnPropNameInRow="BillToAddressId" msprop:Generator_ColumnVarNameInTable="columnBillToAddressId" msprop:Generator_ColumnPropNameInTable="BillToAddressIdColumn" type="xs:int" />
              <xs:element name="ShipToAddressId" msprop:Generator_UserColumnName="ShipToAddressId" msprop:Generator_ColumnPropNameInRow="ShipToAddressId" msprop:Generator_ColumnVarNameInTable="columnShipToAddressId" msprop:Generator_ColumnPropNameInTable="ShipToAddressIdColumn" type="xs:int" />
              <xs:element name="ShipMethodId" msprop:Generator_UserColumnName="ShipMethodId" msprop:Generator_ColumnPropNameInRow="ShipMethodId" msprop:Generator_ColumnVarNameInTable="columnShipMethodId" msprop:Generator_ColumnPropNameInTable="ShipMethodIdColumn" type="xs:int" />
              <xs:element name="CurrencyRateId" msprop:Generator_UserColumnName="CurrencyRateId" msprop:Generator_ColumnPropNameInRow="CurrencyRateId" msprop:Generator_ColumnVarNameInTable="columnCurrencyRateId" msprop:Generator_ColumnPropNameInTable="CurrencyRateIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SubTotal" msprop:Generator_UserColumnName="SubTotal" msprop:Generator_ColumnPropNameInRow="SubTotal" msprop:Generator_ColumnVarNameInTable="columnSubTotal" msprop:Generator_ColumnPropNameInTable="SubTotalColumn" type="xs:decimal" />
              <xs:element name="TaxAmt" msprop:Generator_UserColumnName="TaxAmt" msprop:Generator_ColumnPropNameInRow="TaxAmt" msprop:Generator_ColumnVarNameInTable="columnTaxAmt" msprop:Generator_ColumnPropNameInTable="TaxAmtColumn" type="xs:decimal" />
              <xs:element name="Freight" msprop:Generator_UserColumnName="Freight" msprop:Generator_ColumnPropNameInRow="Freight" msprop:Generator_ColumnVarNameInTable="columnFreight" msprop:Generator_ColumnPropNameInTable="FreightColumn" type="xs:decimal" />
              <xs:element name="TotalDue" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TotalDue" msprop:Generator_ColumnPropNameInRow="TotalDue" msprop:Generator_ColumnVarNameInTable="columnTotalDue" msprop:Generator_ColumnPropNameInTable="TotalDueColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Comment" msprop:Generator_UserColumnName="Comment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInTable="CommentColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" />
              <xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TS" msprop:Generator_ColumnPropNameInRow="TS" msprop:Generator_ColumnVarNameInTable="columnTS" msprop:Generator_ColumnPropNameInTable="TSColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Customer" msprop:Generator_UserTableName="Customer" msprop:Generator_RowDeletedName="CustomerRowDeleted" msprop:Generator_TableClassName="CustomerDataTable" msprop:Generator_RowChangedName="CustomerRowChanged" msprop:Generator_RowClassName="CustomerRow" msprop:Generator_RowChangingName="CustomerRowChanging" msprop:Generator_RowEvArgName="CustomerRowChangeEvent" msprop:Generator_RowEvHandlerName="CustomerRowChangeEventHandler" msprop:Generator_TablePropName="Customer" msprop:Generator_TableVarName="tableCustomer" msprop:Generator_RowDeletingName="CustomerRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CustomerId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="CustomerId" msprop:Generator_ColumnPropNameInRow="CustomerId" msprop:Generator_ColumnVarNameInTable="columnCustomerId" msprop:Generator_ColumnPropNameInTable="CustomerIdColumn" type="xs:int" />
              <xs:element name="AccountNumber" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AccountNumber" msprop:Generator_ColumnPropNameInRow="AccountNumber" msprop:Generator_ColumnVarNameInTable="columnAccountNumber" msprop:Generator_ColumnPropNameInTable="AccountNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Demographics" msprop:Generator_UserColumnName="Demographics" msprop:Generator_ColumnPropNameInRow="Demographics" msprop:Generator_ColumnVarNameInTable="columnDemographics" msprop:Generator_ColumnPropNameInTable="DemographicsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryCode" msprop:Generator_UserColumnName="CountryCode" msprop:Generator_ColumnPropNameInRow="CountryCode" msprop:Generator_ColumnVarNameInTable="columnCountryCode" msprop:Generator_ColumnPropNameInTable="CountryCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PreferredShipMethod" msprop:Generator_UserColumnName="PreferredShipMethod" msprop:Generator_ColumnPropNameInRow="PreferredShipMethod" msprop:Generator_ColumnVarNameInTable="columnPreferredShipMethod" msprop:Generator_ColumnPropNameInTable="PreferredShipMethodColumn" type="xs:int" minOccurs="0" />
              <xs:element name="PreferredPaymentTerm" msprop:Generator_UserColumnName="PreferredPaymentTerm" msprop:Generator_ColumnPropNameInRow="PreferredPaymentTerm" msprop:Generator_ColumnVarNameInTable="columnPreferredPaymentTerm" msprop:Generator_ColumnPropNameInTable="PreferredPaymentTermColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="VergiDairesi" msprop:Generator_UserColumnName="VergiDairesi" msprop:Generator_ColumnPropNameInRow="VergiDairesi" msprop:Generator_ColumnVarNameInTable="columnVergiDairesi" msprop:Generator_ColumnPropNameInTable="VergiDairesiColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VergiNo" msprop:Generator_UserColumnName="VergiNo" msprop:Generator_ColumnPropNameInRow="VergiNo" msprop:Generator_ColumnVarNameInTable="columnVergiNo" msprop:Generator_ColumnPropNameInTable="VergiNoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" />
              <xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TS" msprop:Generator_ColumnPropNameInRow="TS" msprop:Generator_ColumnVarNameInTable="columnTS" msprop:Generator_ColumnPropNameInTable="TSColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Address" msprop:Generator_UserTableName="Address" msprop:Generator_RowDeletedName="AddressRowDeleted" msprop:Generator_TableClassName="AddressDataTable" msprop:Generator_RowChangedName="AddressRowChanged" msprop:Generator_RowClassName="AddressRow" msprop:Generator_RowChangingName="AddressRowChanging" msprop:Generator_RowEvArgName="AddressRowChangeEvent" msprop:Generator_RowEvHandlerName="AddressRowChangeEventHandler" msprop:Generator_TablePropName="Address" msprop:Generator_TableVarName="tableAddress" msprop:Generator_RowDeletingName="AddressRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AddressId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="AddressId" msprop:Generator_ColumnPropNameInRow="AddressId" msprop:Generator_ColumnVarNameInTable="columnAddressId" msprop:Generator_ColumnPropNameInTable="AddressIdColumn" type="xs:int" />
              <xs:element name="AddressLine1" msprop:Generator_UserColumnName="AddressLine1" msprop:Generator_ColumnPropNameInRow="AddressLine1" msprop:Generator_ColumnVarNameInTable="columnAddressLine1" msprop:Generator_ColumnPropNameInTable="AddressLine1Column">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AddressLine2" msprop:Generator_UserColumnName="AddressLine2" msprop:Generator_ColumnPropNameInRow="AddressLine2" msprop:Generator_ColumnVarNameInTable="columnAddressLine2" msprop:Generator_ColumnPropNameInTable="AddressLine2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_UserColumnName="City" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInTable="CityColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="State" msprop:Generator_UserColumnName="State" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInTable="StateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryCode" msprop:Generator_UserColumnName="CountryCode" msprop:Generator_ColumnPropNameInRow="CountryCode" msprop:Generator_ColumnVarNameInTable="columnCountryCode" msprop:Generator_ColumnPropNameInTable="CountryCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PostalCode" msprop:Generator_UserColumnName="PostalCode" msprop:Generator_ColumnPropNameInRow="PostalCode" msprop:Generator_ColumnVarNameInTable="columnPostalCode" msprop:Generator_ColumnPropNameInTable="PostalCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UseCount" msprop:Generator_UserColumnName="UseCount" msprop:Generator_ColumnPropNameInRow="UseCount" msprop:Generator_ColumnVarNameInTable="columnUseCount" msprop:Generator_ColumnPropNameInTable="UseCountColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" />
              <xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TS" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TS" msprop:Generator_ColumnPropNameInRow="TS" msprop:Generator_ColumnVarNameInTable="columnTS" msprop:Generator_ColumnPropNameInTable="TSColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="BankAccount" msprop:Generator_UserTableName="BankAccount" msprop:Generator_RowDeletedName="BankAccountRowDeleted" msprop:Generator_TableClassName="BankAccountDataTable" msprop:Generator_RowChangedName="BankAccountRowChanged" msprop:Generator_RowClassName="BankAccountRow" msprop:Generator_RowChangingName="BankAccountRowChanging" msprop:Generator_RowEvArgName="BankAccountRowChangeEvent" msprop:Generator_RowEvHandlerName="BankAccountRowChangeEventHandler" msprop:Generator_TablePropName="BankAccount" msprop:Generator_TableVarName="tableBankAccount" msprop:Generator_RowDeletingName="BankAccountRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="BankAccountId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="BankAccountId" msprop:Generator_ColumnPropNameInRow="BankAccountId" msprop:Generator_ColumnVarNameInTable="columnBankAccountId" msprop:Generator_ColumnPropNameInTable="BankAccountIdColumn" type="xs:int" />
              <xs:element name="BankName" msprop:Generator_UserColumnName="BankName" msprop:Generator_ColumnPropNameInRow="BankName" msprop:Generator_ColumnVarNameInTable="columnBankName" msprop:Generator_ColumnPropNameInTable="BankNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BranchName" msprop:Generator_UserColumnName="BranchName" msprop:Generator_ColumnPropNameInRow="BranchName" msprop:Generator_ColumnVarNameInTable="columnBranchName" msprop:Generator_ColumnPropNameInTable="BranchNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BranchCode" msprop:Generator_UserColumnName="BranchCode" msprop:Generator_ColumnPropNameInRow="BranchCode" msprop:Generator_ColumnVarNameInTable="columnBranchCode" msprop:Generator_ColumnPropNameInTable="BranchCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryCode" msprop:Generator_UserColumnName="CountryCode" msprop:Generator_ColumnPropNameInRow="CountryCode" msprop:Generator_ColumnVarNameInTable="columnCountryCode" msprop:Generator_ColumnPropNameInTable="CountryCodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccountNumber" msprop:Generator_UserColumnName="AccountNumber" msprop:Generator_ColumnPropNameInRow="AccountNumber" msprop:Generator_ColumnVarNameInTable="columnAccountNumber" msprop:Generator_ColumnPropNameInTable="AccountNumberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IBANCode" msprop:Generator_UserColumnName="IBANCode" msprop:Generator_ColumnPropNameInRow="IBANCode" msprop:Generator_ColumnVarNameInTable="columnIBANCode" msprop:Generator_ColumnPropNameInTable="IBANCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UseCount" msprop:Generator_UserColumnName="UseCount" msprop:Generator_ColumnPropNameInRow="UseCount" msprop:Generator_ColumnVarNameInTable="columnUseCount" msprop:Generator_ColumnPropNameInTable="UseCountColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SalesAgent" />
      <xs:field xpath="mstns:SalesAgentId" />
    </xs:unique>
    <xs:unique name="SalesAgentSales_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SalesAgentSales" />
      <xs:field xpath="mstns:SalesAgentId" />
      <xs:field xpath="mstns:SalesOrderId" />
    </xs:unique>
    <xs:unique name="SalesAgentAddress_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SalesAgentAddress" />
      <xs:field xpath="mstns:SalesAgentId" />
      <xs:field xpath="mstns:AddressId" />
    </xs:unique>
    <xs:unique name="SalesAgentBankAccount_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SalesAgentBankAccount" />
      <xs:field xpath="mstns:BankAccountId" />
      <xs:field xpath="mstns:SalesAgentId" />
    </xs:unique>
    <xs:unique name="SalesAgentCustomer_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SalesAgentCustomer" />
      <xs:field xpath="mstns:SalesAgentId" />
      <xs:field xpath="mstns:CustomerId" />
      <xs:field xpath="mstns:StartDate" />
    </xs:unique>
    <xs:unique name="SalesOrderHeader_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SalesOrderHeader" />
      <xs:field xpath="mstns:SalesOrderId" />
    </xs:unique>
    <xs:unique name="Customer_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Customer" />
      <xs:field xpath="mstns:CustomerId" />
    </xs:unique>
    <xs:unique name="Address_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Address" />
      <xs:field xpath="mstns:AddressId" />
    </xs:unique>
    <xs:unique name="BankAccount_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BankAccount" />
      <xs:field xpath="mstns:BankAccountId" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_SalesAgentCommission_SalesAgent" msdata:parent="SalesAgent" msdata:child="SalesAgentSales" msdata:parentkey="SalesAgentId" msdata:childkey="SalesAgentId" msprop:Generator_UserRelationName="FK_SalesAgentCommission_SalesAgent" msprop:Generator_RelationVarName="relationFK_SalesAgentCommission_SalesAgent" msprop:Generator_UserChildTable="SalesAgentSales" msprop:Generator_UserParentTable="SalesAgent" msprop:Generator_ParentPropName="SalesAgentRow" msprop:Generator_ChildPropName="GetSalesAgentSalesRows" />
      <msdata:Relationship name="FK_SalesAgentAddress_SalesAgent" msdata:parent="SalesAgent" msdata:child="SalesAgentAddress" msdata:parentkey="SalesAgentId" msdata:childkey="SalesAgentId" msprop:Generator_UserRelationName="FK_SalesAgentAddress_SalesAgent" msprop:Generator_RelationVarName="relationFK_SalesAgentAddress_SalesAgent" msprop:Generator_UserChildTable="SalesAgentAddress" msprop:Generator_UserParentTable="SalesAgent" msprop:Generator_ParentPropName="SalesAgentRow" msprop:Generator_ChildPropName="GetSalesAgentAddressRows" />
      <msdata:Relationship name="FK_SalesAgentBankAccount_SalesAgent" msdata:parent="SalesAgent" msdata:child="SalesAgentBankAccount" msdata:parentkey="SalesAgentId" msdata:childkey="SalesAgentId" msprop:Generator_UserRelationName="FK_SalesAgentBankAccount_SalesAgent" msprop:Generator_RelationVarName="relationFK_SalesAgentBankAccount_SalesAgent" msprop:Generator_UserChildTable="SalesAgentBankAccount" msprop:Generator_UserParentTable="SalesAgent" msprop:Generator_ParentPropName="SalesAgentRow" msprop:Generator_ChildPropName="GetSalesAgentBankAccountRows" />
      <msdata:Relationship name="FK_SalesAgentCustomer_SalesAgent" msdata:parent="SalesAgent" msdata:child="SalesAgentCustomer" msdata:parentkey="SalesAgentId" msdata:childkey="SalesAgentId" msprop:Generator_UserRelationName="FK_SalesAgentCustomer_SalesAgent" msprop:Generator_RelationVarName="relationFK_SalesAgentCustomer_SalesAgent" msprop:Generator_UserChildTable="SalesAgentCustomer" msprop:Generator_UserParentTable="SalesAgent" msprop:Generator_ParentPropName="SalesAgentRow" msprop:Generator_ChildPropName="GetSalesAgentCustomerRows" />
      <msdata:Relationship name="FK_SalesAgentPayment_SalesAgent" msdata:parent="SalesAgent" msdata:child="SalesAgentPayment" msdata:parentkey="SalesAgentId" msdata:childkey="SalesAgentId" msprop:Generator_UserRelationName="FK_SalesAgentPayment_SalesAgent" msprop:Generator_RelationVarName="relationFK_SalesAgentPayment_SalesAgent" msprop:Generator_UserChildTable="SalesAgentPayment" msprop:Generator_UserParentTable="SalesAgent" msprop:Generator_ParentPropName="SalesAgentRow" msprop:Generator_ChildPropName="GetSalesAgentPaymentRows" />
      <msdata:Relationship name="FK_SalesAgentSales_SalesOrderHeader" msdata:parent="SalesOrderHeader" msdata:child="SalesAgentSales" msdata:parentkey="SalesOrderId" msdata:childkey="SalesOrderId" msprop:Generator_UserRelationName="FK_SalesAgentSales_SalesOrderHeader" msprop:Generator_RelationVarName="relationFK_SalesAgentSales_SalesOrderHeader" msprop:Generator_UserChildTable="SalesAgentSales" msprop:Generator_UserParentTable="SalesOrderHeader" msprop:Generator_ParentPropName="SalesOrderHeaderRow" msprop:Generator_ChildPropName="GetSalesAgentSalesRows" />
      <msdata:Relationship name="FK_SalesOrderHeader_SalesAgent" msdata:parent="SalesAgent" msdata:child="SalesOrderHeader" msdata:parentkey="SalesAgentId" msdata:childkey="SalesAgentId" msprop:Generator_UserRelationName="FK_SalesOrderHeader_SalesAgent" msprop:Generator_RelationVarName="relationFK_SalesOrderHeader_SalesAgent" msprop:Generator_UserChildTable="SalesOrderHeader" msprop:Generator_UserParentTable="SalesAgent" msprop:Generator_ParentPropName="SalesAgentRow" msprop:Generator_ChildPropName="GetSalesOrderHeaderRows" />
      <msdata:Relationship name="FK_SalesAgentCustomer_Customer" msdata:parent="Customer" msdata:child="SalesAgentCustomer" msdata:parentkey="CustomerId" msdata:childkey="CustomerId" msprop:Generator_UserRelationName="FK_SalesAgentCustomer_Customer" msprop:Generator_RelationVarName="relationFK_SalesAgentCustomer_Customer" msprop:Generator_UserChildTable="SalesAgentCustomer" msprop:Generator_UserParentTable="Customer" msprop:Generator_ParentPropName="CustomerRow" msprop:Generator_ChildPropName="GetSalesAgentCustomerRows" />
      <msdata:Relationship name="FK_SalesOrderHeader_Customer_CustomerId" msdata:parent="Customer" msdata:child="SalesOrderHeader" msdata:parentkey="CustomerId" msdata:childkey="CustomerId" msprop:Generator_UserRelationName="FK_SalesOrderHeader_Customer_CustomerId" msprop:Generator_RelationVarName="relationFK_SalesOrderHeader_Customer_CustomerId" msprop:Generator_UserChildTable="SalesOrderHeader" msprop:Generator_UserParentTable="Customer" msprop:Generator_ParentPropName="CustomerRow" msprop:Generator_ChildPropName="GetSalesOrderHeaderRows" />
      <msdata:Relationship name="FK_SalesAgentAddress_Address" msdata:parent="Address" msdata:child="SalesAgentAddress" msdata:parentkey="AddressId" msdata:childkey="AddressId" msprop:Generator_UserRelationName="FK_SalesAgentAddress_Address" msprop:Generator_RelationVarName="relationFK_SalesAgentAddress_Address" msprop:Generator_UserChildTable="SalesAgentAddress" msprop:Generator_UserParentTable="Address" msprop:Generator_ParentPropName="AddressRow" msprop:Generator_ChildPropName="GetSalesAgentAddressRows" />
      <msdata:Relationship name="FK_SalesAgentBankAccount_BankAccount" msdata:parent="BankAccount" msdata:child="SalesAgentBankAccount" msdata:parentkey="BankAccountId" msdata:childkey="BankAccountId" msprop:Generator_UserRelationName="FK_SalesAgentBankAccount_BankAccount" msprop:Generator_RelationVarName="relationFK_SalesAgentBankAccount_BankAccount" msprop:Generator_UserChildTable="SalesAgentBankAccount" msprop:Generator_UserParentTable="BankAccount" msprop:Generator_ParentPropName="BankAccountRow" msprop:Generator_ChildPropName="GetSalesAgentBankAccountRows" />
      <msdata:Relationship name="FK_SalesOrderHeader_Address_BillToAddressId" msdata:parent="Address" msdata:child="SalesOrderHeader" msdata:parentkey="AddressId" msdata:childkey="BillToAddressId" msprop:Generator_UserRelationName="FK_SalesOrderHeader_Address_BillToAddressId" msprop:Generator_RelationVarName="relationFK_SalesOrderHeader_Address_BillToAddressId" msprop:Generator_UserChildTable="SalesOrderHeader" msprop:Generator_UserParentTable="Address" msprop:Generator_ParentPropName="AddressRowByFK_SalesOrderHeader_Address_BillToAddressId" msprop:Generator_ChildPropName="GetSalesOrderHeaderRowsByFK_SalesOrderHeader_Address_BillToAddressId" />
      <msdata:Relationship name="FK_SalesOrderHeader_Address_ShipToAddressId" msdata:parent="Address" msdata:child="SalesOrderHeader" msdata:parentkey="AddressId" msdata:childkey="ShipToAddressId" msprop:Generator_UserRelationName="FK_SalesOrderHeader_Address_ShipToAddressId" msprop:Generator_RelationVarName="relationFK_SalesOrderHeader_Address_ShipToAddressId" msprop:Generator_UserChildTable="SalesOrderHeader" msprop:Generator_UserParentTable="Address" msprop:Generator_ParentPropName="AddressRowByFK_SalesOrderHeader_Address_ShipToAddressId" msprop:Generator_ChildPropName="GetSalesOrderHeaderRowsByFK_SalesOrderHeader_Address_ShipToAddressId" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>